import pandas as pd

df = pd.read_excel("query_20250519_resp_2.5_vs_3.xlsx")
df['history'] = df['history'].apply(lambda x:eval(x)[:-1])
df = df.drop(['messages','openFlag'],axis=1)
print(df['history'].head())

df.columns = [
    "id","dialogId","系统Prompt","历史对话",	"qwen2.5-72b","qwen3-30b","用户回复"
]
df = df.drop(["id"],axis=1)
df.to_excel("query_20250520_resp_2.5_vs_3_man.xlsx",index=False)
